package kr.co.kiso.usr.common.dao;

import java.util.List;

import kr.co.kiso.usr.common.BaseDao;
import kr.co.kiso.usr.common.vo.CommonVo;

import org.springframework.stereotype.Repository;

@Repository
public class CommonDao extends BaseDao {
	@SuppressWarnings("unchecked")
	public List CMNG010Q(CommonVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList(
				"common.CMNG010Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int CMNG010Q_CNT() throws Exception {
		int dd = (Integer) getSqlMapClientTemplate().queryForObject("common.CMNG010Q_CNT");
		return dd;
	}
	
	
	public List CMNG020Q(CommonVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList(
				"common.CMNG020Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int CMNG020Q_CNT(CommonVo vo) throws Exception {
		int dd = (Integer) getSqlMapClientTemplate().queryForObject("common.CMNG020Q_CNT",vo);
		return dd;
	}
	
	@SuppressWarnings("unchecked")
	public void CMNG030T(CommonVo vo) throws Exception {
		 getSqlMapClientTemplate().insert("common.CMNG030T",vo);
	}
	
	@SuppressWarnings("unchecked")
	public int CMNG040T(CommonVo vo) throws Exception {
		 return getSqlMapClientTemplate().update("common.CMNG040T",vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public int CMNG050T(CommonVo vo) throws Exception {
		 return getSqlMapClientTemplate().delete("common.CMNG050T",vo);
	}
	
	public List CMNG060Q(String code_p_seq_no) throws Exception {
		return getSqlMapClientTemplate().queryForList(
				"common.CMNG060Q", code_p_seq_no);
	}
	public List CMNG070Q(String code_p_seq_no) throws Exception {
		return getSqlMapClientTemplate().queryForList(
				"common.CMNG070Q", code_p_seq_no);
	}
	
	
}
